SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421491 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421491 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692947,453779,592010,31705,708526,1041157,395024,152964,633755,235361,779731,563719,730827,489007,942364,119926,158026,15578,275434,305850,961905,830027,603035,837174,483495,841013,258453,725106,280735,1012411,738106,289779,514520,139085,493576,477770,648715,862321,796520,372229,399670,202267,544441,871041,915046,732470,487604,771850,137291,982382,13254,827154,37181,1037973,156733,455062,373846,335418,302095,624691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]