SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427815 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427815 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772271,802909,905879,345376,953266,872121,1029095,16514,948415,711147,1029766,536144,123908,105821,770623,131323,128345,550316,102310,509708,490881,522243,515972,977918,886449,419922,505764,434846,825867,699853,428748,574917,398373,390,376311,494079,463305,359193,351984,981609,525538,992249,72597,388059,321962,325883,707712,389461,349466,738938,712216,123514,933765,232700,201466,543908,729883,1035415,303102,179326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]