SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501186 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501186 [ RunTime:0.006276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811604,298718,952057,362012,860766,211584,788615,291105,586588,657245,291557,35936,337690,520120,147936,847882,540800,211405,905821,100429,136088,1007510,884811,947611,833323,68063,1004812,603651,952316,663400,373580,321162,1023648,473187,177065,143356,725221,431731,579599,382322,967087,244143,30569,540414,149532,751538,987627,655587,474436,972875,563718,186095,366519,357686,269232,232688,371187,800946,854168,540763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]