SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112006 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112006 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011328,216885,342912,421657,190519,949829,537532,445397,845219,473928,9360,763033,626987,228543,932363,892780,246294,136415,540322,60612,84336,65936,316577,899480,550466,147908,1048365,184120,715126,244017,139142,289106,520539,391395,37195,399663,976179,28195,155878,808976,338357,381988,436925,611059,16079,950686,581853,917436,464549,934755,153213,830716,217213,926946,653692,451943,542268,892714,1026897,471336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]