SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331685 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331685 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617883,456269,212871,295311,1010310,613054,24259,986968,439816,340934,706720,968022,408681,654410,777024,214243,932437,192492,813429,69046,9449,1008783,348563,349830,339678,409518,18982,1028768,588050,995831,281992,715702,44348,545780,822938,889404,670759,28664,151532,70523,727514,999873,127446,763243,37963,578212,602275,1018046,593744,869679,667012,427166,102373,541115,672395,1008136,479623,159741,155379,866548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]