SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413425 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413425 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412236,395325,107718,853344,392744,1017326,964963,206928,412905,493384,1029696,282660,156293,49996,820042,820961,152624,103117,663609,442084,904945,201889,730312,993633,65317,176709,572944,101536,514547,905554,739475,961379,279908,63193,305883,295256,280258,701952,145622,920482,689617,1019254,180386,915577,523950,382129,607958,88568,875117,715703,32340,47934,536881,128236,466103,295225,312552,423855,290534,611921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001780s ]