SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447482 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447482 [ RunTime:0.002347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852490,593249,645363,650313,421924,743087,884423,255500,204665,322001,405354,824394,413669,536606,731130,636898,767724,735226,261839,301862,936107,548698,185515,155964,825905,482602,349758,292822,249343,647317,400462,223372,868059,845807,711095,254854,626238,208657,554400,166160,116223,43508,98762,1351,607748,766876,826428,949492,412490,379184,22226,1011955,885674,8568,780311,75130,377191,204310,252553,1041252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]