SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435399 LIMIT 1 [ RunTime:0.000853s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435399 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330227,562214,861883,297278,515857,863790,279301,879970,1018677,621596,485087,913762,38078,942355,205238,748099,402734,302507,419921,603328,492158,270245,506464,59757,577970,26858,133596,511011,205214,201206,669791,601855,126208,759879,823746,822160,121176,346754,816531,198723,280265,240941,868087,681281,1018823,623669,70011,498238,342712,781476,275072,911144,889489,88626,336143,131269,419020,767014,172672,744815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]