SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382551 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382551 [ RunTime:0.002624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71146,888271,210084,119132,818949,458009,422519,714128,622161,60818,353954,497412,234480,283150,969913,730775,975454,571703,611289,498970,250669,871428,494554,782836,958004,1010313,981850,229355,609213,1020884,249944,704570,1030393,490370,479505,755313,873107,561242,499222,785778,299249,288021,421397,689999,137350,566911,424734,684609,855169,925177,313638,532645,218956,1045357,425379,666854,423206,722539,98260,172616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]