SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548881 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548881 [ RunTime:0.002950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394085,421773,18734,30073,463940,478493,1037508,333741,637847,219931,806631,744905,347931,369476,604903,500916,343228,484048,606414,344060,957954,32514,462095,228876,231699,903382,69421,746365,908110,34426,985537,151,710832,91286,341401,623712,88637,395732,401066,766984,663632,148109,217362,838318,541800,285590,666540,622247,131832,999095,890969,331593,176741,230156,766599,572664,56354,793963,748102,836502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]