SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038392 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038392 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284977,179695,511209,554398,852040,209927,226475,499150,99143,371357,281101,272261,991319,513729,617215,441107,772410,504301,40620,271014,909913,316615,202914,256842,530488,756934,719034,626658,986561,1011924,663247,214558,930589,486047,411243,844238,518230,199096,444681,172869,800814,799665,284836,615462,212979,978262,955319,341373,292394,109624,358441,96535,156106,483121,196236,990944,23229,142935,453079,932563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]