SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334754 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334754 [ RunTime:0.003295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425392,269193,180531,753081,529787,48618,355230,745612,774154,507233,892635,267430,84034,391378,371408,703519,514632,316093,433022,425384,228751,727121,372249,472749,381649,666390,749627,216190,564081,844134,105789,1019340,581860,352704,68171,55829,805383,608363,576391,567415,816608,492020,475242,324130,411256,190226,1042690,51089,1035375,321889,425033,259309,618084,484638,381413,350535,228651,298900,244984,818163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]