SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197890 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197890 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427959,779,867495,52727,129486,832820,456063,387848,127630,572448,886753,339468,798670,570341,485373,363717,3425,513030,476434,522264,123003,544001,376550,1041379,148206,626815,681707,507414,315152,103858,705107,877318,551238,34354,923988,41426,67094,841004,932998,206170,9853,209997,871523,920411,920870,265319,984646,203954,143169,680966,973048,164131,705613,866846,150859,1020405,642610,148764,789087,866845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]