SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405171 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405171 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218820,531206,675665,771888,235330,192360,404199,611775,677631,943053,829461,117476,959020,456254,849986,21520,623265,119382,883644,859884,744964,222253,702122,806785,85278,863409,672202,123095,499035,957687,135530,497457,405348,448765,867690,159958,795957,317443,993489,756959,431415,323128,697013,794800,802772,352620,93751,127813,251861,818571,52939,837220,1003625,191525,458959,54877,609401,216073,195850,404764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]