SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004474 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004474 [ RunTime:0.005429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780594,52990,120643,1000753,800601,342984,427013,369475,316773,52040,445629,664308,631102,534824,620247,129221,282522,196238,794056,401138,5809,498326,121169,210159,942320,876346,228551,674879,357473,916797,931417,902467,81,115906,616300,339794,980891,245169,827131,967687,353232,646600,1030228,641849,828917,247061,255119,764489,777460,105603,730023,962740,856722,1044710,142497,161085,633492,999799,407893,992085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001717s ]