SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006579s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423253 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423253 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629601,134507,284018,611414,1023154,612139,1008162,129212,802005,527052,1025749,574632,208019,874435,201216,672704,846593,848206,254152,677080,267881,992038,854937,498409,1026147,914501,209582,626188,862978,212933,377343,924264,263204,849928,44396,930702,108093,746359,873027,79426,621276,658826,97182,1037489,669661,549976,863931,303367,412028,22262,62894,107849,131158,842534,842000,994587,28857,109545,398067,41017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003123s ]