SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036536 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036536 [ RunTime:0.002335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792410,379761,187028,502004,379099,340468,201114,581128,360000,985902,203574,194835,329277,667011,487707,1018228,697643,812077,827874,187058,806752,613425,515728,355672,155912,16442,147690,626585,107913,425807,73931,860972,950343,381669,904612,353270,569966,756397,430449,40403,305430,412912,172450,191007,927186,244856,701135,379647,171351,886200,73289,786006,992510,426407,935772,396134,708263,477063,647331,529054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]