SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042076 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042076 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211867,538602,311378,456292,56825,825122,335357,111436,672986,433769,536290,849185,625572,1024553,291593,363331,660405,261472,170774,268808,744850,644747,136183,615877,499936,730407,252840,773886,514091,1023384,210784,580184,922177,416148,385794,1011977,339649,91024,448655,1037694,509406,804847,929746,54454,81348,776218,948349,127708,513832,253601,198584,565151,46154,580301,191644,988529,997219,202997,427908,533662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000876s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000839s ]