SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672681 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672681 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550975,336032,204954,538713,110917,136315,660160,190260,775502,59045,165279,568270,753396,174123,22411,1034412,76496,294011,908565,680680,949001,372772,1027985,89651,213885,1016435,1029063,160413,53227,145838,414555,313887,250429,362003,981428,492891,235162,632157,739239,351803,857226,559275,642902,199364,988544,1014952,934580,6966,58136,823160,507568,724986,575589,244210,1022248,908645,654572,169754,400669,64463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]