SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40930 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40930 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625083,1001947,864619,949311,435316,390218,395468,465503,202218,191086,329719,149709,816298,21423,383244,925105,197356,383403,466181,822427,745242,603984,929007,284043,534600,994342,968177,934339,686683,354134,949866,518884,747424,611980,787391,646268,722322,652710,868200,847722,1018743,1020315,319292,945758,127575,498801,434233,937796,964332,104477,729081,22158,576349,974308,131997,196824,987178,49145,740654,146810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]