SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019096 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019096 [ RunTime:0.004138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571658,860260,498325,967818,799086,899295,660306,272959,476228,503742,198946,650820,376990,859445,788469,292424,740407,691999,287700,618162,30793,433770,317936,844326,648749,162248,573866,770253,652545,211797,61427,889177,43962,780370,861838,566250,973952,54802,528300,107754,504063,102399,899663,803237,755908,120694,960057,944731,340499,479571,534067,620893,299228,1004728,990540,588509,846793,639025,693828,552556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002504s ]