SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406017 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406017 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270243,822261,776615,842044,367145,172223,869051,104172,315488,570546,349898,740863,610689,163868,797949,215180,671459,412623,259316,134872,968400,1024894,180614,758922,915360,489819,249060,326413,627816,260531,1038720,299181,45625,734182,121226,232551,1011448,1032830,72080,341077,882157,991595,560252,158987,970623,383611,376624,219942,647702,109289,86309,643046,875624,122263,748571,172423,458268,109687,31333,618724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000790s ]