SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394470 LIMIT 1 [ RunTime:0.002548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394470 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509508,148489,304951,208935,434191,980114,481897,964832,647906,133859,6517,175237,543229,463314,935158,529464,424723,138456,608537,524018,584721,398541,696696,461666,839531,726189,857519,129499,737218,918383,804902,273219,121899,233449,807943,179188,812002,193999,373283,1037100,4495,236586,208437,639406,150027,873769,576692,109883,903467,310630,50952,551486,277327,1019901,321167,812654,656690,479389,96348,294235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004779s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001255s ]