SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004002s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414801 LIMIT 1 [ RunTime:0.025261s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414801 [ RunTime:0.007274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95528,5922,197995,602602,56078,929146,89303,197574,598356,302036,901277,458399,825314,638479,604881,90611,644414,1047063,428942,730717,567030,462169,294517,777774,549138,811954,1019151,526399,957105,202471,14553,1039171,447264,879606,186625,89031,60040,74943,400158,234053,590066,521615,440304,216848,858399,143403,5869,606307,773872,916450,624038,666632,463178,202109,942908,627897,7132,242147,631098,492505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006159s ]