SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190430 LIMIT 1 [ RunTime:0.000993s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190430 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325456,71842,918185,72613,1011424,825533,355433,383623,649353,163149,171602,415362,780785,471890,866264,1023692,660143,338303,886976,727566,192734,212507,653522,890404,391700,954996,961690,814555,738107,852972,947592,599672,154417,711013,811332,593361,811118,183541,163252,888290,352775,442778,458985,49088,255145,722433,790059,744850,84379,113039,816194,538275,82660,845887,146872,518176,511851,751999,482529,1009198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]