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` = 530524 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530524 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150808,691798,370061,451549,342781,87139,342807,25964,764744,598311,560720,535755,728935,735425,557446,549774,539268,629299,808374,687669,8076,328868,881917,434207,780700,474648,892876,29450,106334,684635,177425,967721,458496,468151,204226,358230,806752,933508,346977,1001391,629933,652798,190951,115469,713051,450747,204398,431950,215212,955455,348060,450412,818875,438525,153930,149368,893388,240430,986798,208730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]