SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013306 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013306 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541148,991661,481542,885320,311710,761877,617606,386209,27216,209468,966884,459355,732639,634565,838602,679684,147006,699318,403237,65649,294165,723278,298717,1003306,895653,912341,169899,224647,564704,616285,1035350,845287,1006227,458109,155415,45377,671667,543118,97094,135145,293515,808759,236962,341624,692862,685578,472678,400272,622717,806972,21553,75748,685558,921340,16271,98424,701298,34528,781394,499786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]