SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974810 LIMIT 1 [ RunTime:0.001636s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974810 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959182,501194,264185,609207,32299,436331,198307,229637,847135,1003480,406101,492748,751330,864375,418707,789807,892172,334226,294711,175115,805033,72164,134977,566194,665536,218190,918272,81943,661683,1022425,826162,236409,454954,249115,591442,102438,644134,756174,263031,869263,374805,94825,353773,345252,260799,578533,686150,31658,812972,97924,216972,391800,64693,868876,885815,669221,969058,317151,3283,122561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001054s ]