SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380833 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380833 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202668,165860,202460,303198,691800,945575,145825,849367,328114,586592,935272,254301,790570,480003,214001,389548,952518,706424,343339,861192,459870,415498,618146,41814,157219,735058,676718,469246,955103,664392,136393,254335,1026056,823303,1008725,739250,887020,718194,403958,1033894,423609,61939,698547,526532,691664,550149,43216,900704,890984,611394,747863,794193,321366,561223,71520,323667,398750,510696,344324,849173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]