SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401622 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401622 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500823,569946,535744,77302,302231,845133,595386,300043,803878,620274,297140,31299,560135,377923,119683,256609,537211,170143,680062,110967,657022,1021477,484657,661885,672884,132729,148276,758684,762099,178217,22008,87702,990700,302501,449349,203323,830894,309433,1027780,26587,256027,406581,716762,215482,504369,182519,809964,269650,152162,750670,560472,601879,650636,215743,916678,100186,563711,999613,915067,507079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]