SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328500 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328500 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461877,1033708,408833,601076,1041555,273207,161420,1033774,323840,720781,163467,526526,71219,613770,449034,111446,522224,563801,413715,691809,559816,469646,430594,576751,183020,790383,366631,139104,49216,857694,603391,585306,266341,792003,575093,958785,374586,54035,104322,856192,337171,482771,590225,354581,697802,1045251,579432,773462,286524,697607,445990,583549,496474,247684,535458,266377,83855,649418,369162,268509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]