SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045405 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045405 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602176,897813,447431,996490,806578,610925,189960,366924,189273,833935,592856,865555,524006,353438,401131,21641,401162,920901,605354,254592,430004,774657,1023566,359621,114717,908114,79268,585033,318761,52532,173246,470103,380828,299309,463065,672278,592543,89367,867063,291432,720692,571435,176312,196444,938050,396044,471877,823073,1005029,40596,80455,908316,917747,407431,1018602,536826,374381,507269,1036593,671431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]