SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537860 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537860 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868274,592524,863485,256101,292756,249262,150988,575832,207106,661463,186148,363936,1021750,580441,148623,14996,740195,101871,695273,819398,340356,402429,777169,325463,493012,146118,473629,503801,821847,893182,444768,20664,912980,343423,797028,699565,236124,609598,732166,83654,104078,393213,883093,1039968,94531,343946,811918,804286,811638,242777,762411,27556,696984,833866,73593,303112,684046,866076,534850,645231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]