SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 940991 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 940991 [ RunTime:0.002864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348295,38349,770915,541837,1003719,916977,427649,205988,562765,378812,910738,460096,636548,652774,355615,189286,382886,389442,671762,37880,1037512,752671,535240,985013,371764,614015,45964,624246,219390,393454,932798,495988,212117,331167,1045864,526467,987568,357978,457927,185278,538565,487798,915846,650959,385145,609675,182591,935025,370965,638134,1047418,357223,117740,780511,617159,514805,197086,611241,1036444,673683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 940991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 940991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]