SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324300 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324300 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905046,161249,86216,722034,1014897,290178,224500,576561,317713,716250,841884,591957,961338,604607,677520,157154,353860,1010388,463117,352918,105857,353582,741662,127995,453340,423702,906529,221349,341909,857731,886750,982345,591159,165151,532339,663395,515095,911543,1042661,784917,636196,660559,67772,914332,782885,493274,442586,967584,59998,408664,226767,982136,638301,484276,731705,166534,126683,923756,550897,1013946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]