SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516004 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516004 [ RunTime:0.004226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156066,943416,694712,417473,205179,517699,113314,944571,27487,407044,446948,853039,489158,774192,997093,424492,618332,843295,1010834,79929,61320,909067,936716,501108,153147,652247,445871,10338,357504,735252,651139,203561,202963,706173,403302,491001,1001272,854286,954229,939471,622714,184579,796027,929399,597243,133222,546614,379135,162965,64831,169347,1046590,780683,902533,891650,124219,227790,714260,824956,549392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]