SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426048 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426048 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706594,918111,789959,169265,241489,309070,984392,1007352,537558,221446,378169,807769,774625,584293,813815,46544,483310,322493,148917,84937,32465,1003712,225733,707011,320320,690721,892650,697790,1039568,622619,106887,828656,624848,612875,123692,377712,137473,36631,492847,652972,783876,1008891,867912,423335,683096,545312,909802,698682,249737,648223,588766,649931,302055,861369,37302,372022,640170,993061,116819,389188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]