SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408841 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408841 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642488,69773,683623,465061,280317,463869,550258,404587,545036,381663,378790,401024,302585,673905,299313,632852,974057,561743,1029812,545715,341162,953517,458772,970206,808327,454536,337852,502675,762546,217150,1035463,241005,489871,190335,563771,245160,300167,120586,982425,73646,490603,40682,573315,681414,562536,542489,962051,338321,1036556,389654,984535,104536,687372,555064,584873,837381,893767,587692,18077,967613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]