SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405342 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405342 [ RunTime:0.002857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243631,751562,9478,733879,573374,340895,684630,307340,862040,986001,78046,162055,821747,626181,138182,29632,708292,796474,160220,1003258,126964,158765,553827,468831,23177,362571,744791,729060,567060,1028847,359911,280945,488929,832654,626326,455091,752993,901340,524044,591782,62913,419506,1029072,889440,125058,585440,483664,526361,589732,724719,473867,240235,75465,955538,139855,316403,856079,7057,966577,348750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]