SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402607 LIMIT 1 [ RunTime:0.002516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402607 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765222,838137,524666,397552,954062,589959,509296,961461,931253,533710,548224,495305,69296,737473,936603,574276,230348,551437,929280,336289,197802,659274,529142,52467,247268,579441,595247,229371,916089,172838,946489,73232,594165,294335,903653,145207,685134,1028816,684184,899986,42988,301404,312929,15397,464700,934343,183162,553883,7569,313271,19098,912487,968825,544130,637683,474195,485579,372044,947773,989369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]