SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 130423 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 130423 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311742,643265,421709,365289,278431,643837,49371,4992,944749,885288,680998,229532,530260,266733,814738,674479,479145,901591,617461,378471,1018405,21848,787257,766579,821771,16475,665459,679256,138306,326007,362064,458636,995561,373394,181679,3181,345421,1002239,778746,310811,519361,467018,415789,42845,625963,178926,420540,50006,656710,705895,186943,161990,379317,745752,961030,504908,662282,169867,371312,433320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 130423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 130423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]