SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034055 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034055 [ RunTime:0.002795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76376,595539,58639,539707,871065,290945,96647,593805,217743,234757,147533,797900,341539,108966,344370,485761,726619,43339,904252,631021,851130,131234,1047709,244819,373741,884967,946473,61578,244421,572613,527932,404667,276723,616651,554375,156482,2513,322117,763362,102376,396269,272403,143062,817532,484077,466616,988805,630961,905030,503484,856377,530607,988602,418332,940349,942762,910675,282448,172969,967978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]