SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40543 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40543 [ RunTime:0.002358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54366,850700,872748,459341,253905,516853,19380,356600,216334,607607,479154,568637,698259,509108,140855,554573,931355,711673,204846,899461,561089,662899,375474,399428,518018,220237,438724,631016,390518,662567,520009,299402,352807,977396,286608,622586,347808,25071,840383,825313,1035808,451839,826242,882698,965272,802594,415368,225491,181524,293786,322919,1008976,607178,171449,542880,62272,517234,436366,550085,1037938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]