SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311953 LIMIT 1 [ RunTime:0.004201s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311953 [ RunTime:0.006336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600144,911419,21968,280081,1010311,955614,143801,290151,107134,150400,561521,355151,224361,471937,825940,499333,660738,604183,494068,264383,432942,702022,329919,203172,210804,114893,571842,723275,419604,927567,700319,108512,788712,658945,967717,124895,861029,283282,123463,897137,770835,730081,598819,106508,787624,367707,486316,913193,140105,159590,18224,822357,313513,316723,381106,859107,48624,742319,161517,1045888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000765s ]