SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017760 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017760 [ RunTime:0.002406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117119,496436,396802,277304,100711,838273,76957,446454,764957,1025325,574601,167128,14630,876553,268135,91345,956225,721479,819650,814899,403005,74607,534300,942498,348223,312734,855921,210181,741044,84536,677272,308355,67614,350575,450592,470688,224483,485371,197827,1025427,133924,940409,248987,866249,15545,62601,197906,581857,1004066,400376,910449,1004925,488177,575101,310679,975290,161423,665383,1036424,371205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]