SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502501 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502501 [ RunTime:0.008505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927723,325537,20148,639866,892996,738062,40248,229395,960156,709203,752920,905670,524801,93732,76669,616725,534454,853014,151797,262230,217394,934232,779581,598892,177643,33315,634324,411350,714154,461805,31025,38743,521056,148854,889969,805176,981690,386051,288149,848389,451483,735658,268339,546875,509940,515767,306618,392863,631346,418383,156874,85872,698918,753671,360341,786290,279368,46770,230592,1008840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]