SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317011 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317011 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155224,995934,256509,24661,879321,156094,535312,140547,183912,1030748,133195,202559,210147,771571,852730,745047,170571,618971,977845,684096,59514,518739,504259,313230,223626,460087,912443,904866,901212,101316,131132,439416,627345,89115,612210,708145,164027,233253,1042821,916757,680737,18822,1037598,754467,393494,51906,94611,447260,755098,467563,531744,107675,930168,259478,864554,393671,215232,205649,1817,166749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]