SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433820 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433820 [ RunTime:0.002507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220824,355108,237069,810024,729201,988002,554589,747025,473357,916245,1048302,464926,603898,572908,122931,616929,341358,897341,1011122,43724,315710,344629,285084,841191,659858,899046,145407,453627,261373,1015765,360729,910340,875656,650773,623167,327693,629730,853864,414145,760739,658465,178146,171007,819068,115377,1015135,189644,337842,972879,818344,5228,68252,738495,762591,1023153,312482,747163,594755,875086,478858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000915s ]