SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286091 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286091 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542757,782511,239522,111194,628353,805630,956784,113459,145786,238750,768826,266433,744839,791090,757360,358299,710509,108315,442756,372658,705789,514944,423035,933304,722360,359085,980069,483896,763367,702536,955188,1042301,1036714,194583,375756,776370,373632,711509,1015528,582365,737986,800299,682240,849716,839605,120423,45624,773951,435768,370962,201005,394491,926845,847361,460262,64454,671752,42419,212668,410281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]