SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458302 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458302 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603288,829907,262888,102021,911199,1018516,435593,45022,724239,889064,502294,719815,682043,1003748,85136,568792,216740,449897,916084,36125,898043,549265,48829,348154,278296,562921,935448,1006596,197726,1042808,753649,97782,324966,18604,392794,452527,158548,389313,74238,82498,428440,488450,30925,395208,195743,108203,110300,461694,1003409,127396,270586,562673,36585,166111,419202,385163,301138,304402,927659,759249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000881s ]