SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 781997 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 781997 [ RunTime:0.002384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974901,255035,513350,986450,140447,611689,58212,986712,809512,610646,744660,853210,659284,30240,363161,571268,1026323,1015629,793384,176638,564604,609679,808040,967823,420691,433835,988284,752933,315559,537581,924513,598363,810199,285961,426451,366761,134600,823966,96161,320541,657438,365851,632845,771850,578114,152972,592977,971639,799271,769506,975762,387580,866507,628390,420462,498972,58332,940649,298140,360812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 781997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 781997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]