SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411842 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411842 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247544,429881,693986,385592,753418,939925,98119,84779,491913,252413,402848,880474,610822,581413,665611,574457,565120,870299,870593,271359,204272,141053,989304,861404,568143,675020,291658,558517,173531,130829,312327,384326,280503,846152,911556,96780,530174,932904,1044655,677049,755979,498138,569641,422305,580468,758319,908418,905777,488046,1124,587109,910614,135635,576403,677058,1033678,123473,130704,167874,138198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]