SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429040 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429040 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736456,412228,162258,160596,206890,625590,587579,914741,1002289,184657,41722,5990,65925,700299,955330,539284,256415,792265,792821,962202,315991,189432,815129,990829,667411,618922,889119,199133,950022,239889,995914,825880,162858,757364,193990,992219,486091,803084,204282,651645,58543,410442,402197,433480,423633,540894,761179,917091,697961,982266,74194,775619,182857,571150,447024,884459,546173,705705,254201,196767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]