SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45543 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45543 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892668,787101,598599,749804,479852,470249,287965,264485,121861,924390,430399,780822,464191,1037753,540572,161449,129724,505801,459244,123733,384010,111708,369055,868265,910238,449905,342369,901187,66232,177493,30781,983639,991614,853316,594891,635483,952992,8957,503681,803031,9670,1012118,244487,634133,463680,35336,546979,59674,560417,8027,535675,676721,462775,120445,127611,164999,383196,838962,909113,322763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]