SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511068 LIMIT 1 [ RunTime:0.001138s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511068 [ RunTime:0.003457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378425,973447,939371,131826,820109,1025264,874181,804326,439517,178226,506448,969166,178125,1019953,884912,538005,324928,240532,525526,494647,30889,748903,31509,907994,818537,270546,672299,879255,929658,342732,441027,476397,774141,605147,287368,247328,182360,710121,510243,967309,673953,127610,329688,6053,358063,644463,151852,946946,616114,311521,516700,915809,869533,783416,178858,54165,805820,679812,542924,217857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001779s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000983s ]