SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971465 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971465 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150778,960579,209054,98128,880230,195606,195929,812858,58951,408156,64917,19248,1030575,304201,541353,389394,1047464,156359,53781,801399,606959,880130,777154,1027383,620031,456287,125745,779963,313672,1018129,178459,532022,580908,548845,392029,265840,869176,798022,798796,657749,754719,953045,738291,710708,150925,795524,709359,819291,381977,382810,990740,907087,1021739,879775,295981,624754,18453,939906,747589,478871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971465 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971465 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002174s ]