SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40378 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40378 [ RunTime:0.003329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356446,22428,207927,213261,811420,534190,519544,689660,912319,209517,335060,200229,162139,399151,327694,614847,367975,717024,9441,344701,347471,425321,773039,328325,520292,24485,942625,685561,524840,534041,425758,372667,964044,74220,746062,886876,1002343,470189,620846,124326,682043,340454,385711,96647,751295,506020,244858,619290,805902,647606,550727,574676,267763,210351,199658,156326,339280,632406,241402,909044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001343s ]