SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528810 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528810 [ RunTime:0.002098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740221,979315,345785,465115,44491,30425,702530,528505,1008486,1028300,21411,142187,115655,363925,920904,239105,164318,252550,1039024,608033,801273,479714,590057,617414,95944,47643,534928,684417,149335,756785,367776,470733,600012,746973,907465,347798,77707,51276,535177,777821,302478,481215,79055,211517,272827,281016,470896,633174,412541,781351,561806,884192,658424,675573,58879,629224,855037,411691,304987,575955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]