SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539514 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539514 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759475,462089,657748,707029,739202,52571,338196,402483,775489,183998,665226,965980,829990,76937,878780,651615,760986,718190,349642,154910,827733,39197,136002,205505,610959,694889,979970,576019,742462,1009948,81371,967423,603172,745782,27740,788800,164208,87094,73328,305839,395315,229165,200585,377333,4253,248192,511398,417873,940103,695928,371549,310202,62922,41568,783502,262358,1016728,286472,1004064,106880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]