SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564106 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564106 [ RunTime:0.002301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198482,241506,741152,117934,135089,632539,154269,781471,422774,1026454,393574,101582,489805,618456,778032,602123,10080,778492,75696,852288,515350,608491,463054,249112,766988,947718,445885,275029,147211,633789,554005,972919,785267,392004,1010863,876733,932007,503307,257596,511661,1041467,582852,59460,336680,694852,989665,660911,962472,337955,558252,682861,436635,232189,744751,652477,244328,209125,175348,600933,1046151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]