SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292607 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292607 [ RunTime:0.002163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251213,266899,1017978,266579,23266,70862,261197,497787,1027265,467500,816552,191539,335933,934332,604303,936806,921504,407331,883727,823004,901911,323775,50532,1043420,998080,6776,606427,1030644,19796,14002,1016242,97850,821743,504672,766103,356298,45066,55754,506259,745855,806543,567728,708234,224171,746136,77817,111371,772597,139008,618017,941381,369329,242542,816904,257621,331831,82077,589481,864609,602249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]