SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920315 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920315 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975729,424854,303088,54617,148264,565107,738454,320274,743936,92342,932781,779027,423373,568640,225911,651994,756194,396527,534756,637111,878848,325035,135150,834908,29918,586844,911614,250505,475778,642625,362016,114038,280417,8591,35984,40976,1023701,458171,546786,97556,195098,948820,834767,127943,848610,1019968,378679,973346,793179,495974,270529,241093,59275,285888,714924,801499,163967,892646,935752,785566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005381s ]