SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589812 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589812 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958681,656887,491225,628306,370403,637208,65481,59031,916632,1004361,160712,663923,750546,810070,488136,752468,637496,19391,899895,474171,766208,339046,997661,333699,947766,111176,771020,288826,655839,314236,183043,218602,302710,434359,65562,769484,268814,242352,43105,627849,1001107,6641,575264,588561,806740,689045,778086,1011074,317213,510477,276995,971025,268874,956838,95851,502928,760010,465087,776564,190648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]