SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011177 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011177 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668632,904988,330819,215867,824777,58561,980179,71725,857156,654900,26092,817392,814794,543916,362390,198004,154532,1006202,195352,430319,983367,609323,608308,925749,140261,690100,872442,156122,1040537,647948,552351,812311,684809,586172,707248,864020,393529,213483,863314,922995,619010,453975,202621,971115,232024,129003,403846,944385,479106,555801,950791,753714,871836,633148,915372,528833,114473,780173,435177,934040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011177 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011177 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]