SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109442 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109442 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208566,841667,622919,722662,592241,837194,66466,1035368,286999,487039,372159,709988,384262,852996,95168,639369,221858,413054,7191,929724,758822,69909,948835,262827,830193,505679,958605,395044,978483,310845,905594,99042,153785,996328,83678,573568,93963,254098,613935,919109,379040,265809,1002683,79834,449821,33052,812523,988139,498458,138483,581661,780172,612218,510515,684396,559155,338111,105018,600150,213722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]