SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568243 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568243 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669377,889108,375794,977596,871997,562798,981885,417644,760828,345395,877293,500271,742818,907442,546371,614479,467579,357593,948159,187929,797735,202473,706987,967221,732384,987287,846086,695341,309573,737197,559047,1023045,732735,27085,26187,825660,154056,656682,894881,454929,577018,971914,881714,595713,79213,49173,940755,256535,761299,574258,1040798,551996,837702,132226,912368,752813,489506,449364,376141,365909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]