SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281469 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281469 [ RunTime:0.003540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161688,280968,982717,547962,820804,652773,476698,445834,613784,614319,395817,380192,965925,443519,719143,622373,843450,252908,1035461,364650,356758,585011,320414,561581,693721,398144,306328,316516,720002,767537,621510,796958,372441,869306,27902,750342,602746,238610,174311,218291,145797,314442,296756,1021545,917180,204752,640486,685726,593994,1001249,854246,508092,571581,386554,893197,343429,932973,48026,52387,520279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281469 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281469 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001538s ]