SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002918s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506727 LIMIT 1 [ RunTime:0.001633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506727 [ RunTime:0.003329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720978,445976,246872,239822,803480,343628,337421,511625,39278,721740,383266,88804,259110,411253,497428,229699,913017,825127,247031,983652,715139,214187,157385,353491,623838,713359,1029281,510155,9686,863094,396503,8646,302949,22218,855239,931371,184317,413490,167647,406889,708849,115305,239480,94944,71662,24227,935546,935542,201605,730154,711323,251777,651111,163230,411516,731471,357421,723297,790121,116809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506727 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506727 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]