SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507211 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507211 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237295,93624,391008,517628,79597,383679,816430,196692,652417,355444,484248,882733,56513,723418,291800,448055,204274,955336,177365,369773,225270,1019005,164481,807656,189635,981,292211,795495,436764,83876,25812,922431,258107,301207,103210,361810,26976,496889,816858,728150,843177,418525,119482,10560,124572,94532,978165,359945,485740,423438,591632,367150,598435,975873,526427,943535,364774,71357,515871,635561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]