SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442830 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442830 [ RunTime:0.005388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302589,298509,310937,1043482,389303,638747,73634,332511,1027390,611582,3252,286349,786703,854364,138759,842995,168794,591625,985225,75990,179375,1033688,1045784,786245,745969,652331,929733,359976,237758,1020552,327918,452007,225737,81214,381732,222136,10547,533130,988777,259692,611164,585321,12970,430172,290131,704699,532954,512408,861059,278171,143583,206113,585090,497605,418120,418166,30194,158234,388163,697555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]