SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041045 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041045 [ RunTime:0.001425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615022,1012894,87697,435032,340798,771144,857041,248390,385452,617742,606925,426428,757330,761291,295441,244284,161113,703010,941431,664045,745612,781185,980318,657707,19967,564083,489126,30408,348925,859779,129936,296495,479974,821454,486009,141717,121280,560563,843320,458929,296409,632026,504292,176983,520098,95256,876875,714548,206194,241210,366480,137658,420924,856209,1045101,671769,650598,930911,367502,680211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]