SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 997281 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 997281 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280410,677940,1023557,288113,589997,536839,212650,604712,993841,760781,101206,707142,85938,403945,520513,510912,73656,84420,932331,810066,525183,732262,592013,38657,255517,21676,63901,317043,53194,799100,54176,161367,1032356,776455,452,983048,85668,761663,315972,609283,581670,234992,680340,47899,904987,704381,1037530,747595,69306,956273,120269,1037344,441104,157611,612523,168601,40402,486798,493919,150046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 997281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 997281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]