SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048208 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048208 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592164,149114,605640,947542,105685,176658,350884,401529,1012874,279366,621906,96754,504659,880036,283410,713545,974355,998337,568747,521257,692896,786030,344238,892783,615271,254811,500119,196485,481623,345624,435300,376469,659530,548091,878113,913872,717478,518382,354557,405923,40837,391103,245697,63240,233502,426291,998348,186823,309533,342147,479902,341647,420328,456621,526712,453010,264913,808070,429184,197502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]