SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020031 LIMIT 1 [ RunTime:0.001595s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020031 [ RunTime:0.002788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552534,88295,79604,317776,716004,1034939,630450,480349,574015,779428,223834,87537,829733,506714,928497,304974,738646,1016246,742554,670356,1018225,187657,875142,556723,343834,727654,224035,745981,110024,499550,835408,940855,644766,775203,47643,407116,194743,876072,158261,290055,645004,891344,473133,354794,327357,410362,391956,1043218,100428,284220,298925,296149,700805,94215,563763,605137,502707,635477,471150,421803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]