SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327448 LIMIT 1 [ RunTime:0.000716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327448 [ RunTime:0.004752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032485,893963,634531,634295,276441,784477,631448,797856,586935,199386,652396,157814,475460,86690,63850,801383,71406,273371,162488,225079,259118,877480,582159,735014,186887,789547,692408,1043388,177074,638214,512045,210026,234985,982281,581928,702261,802631,649480,756879,909890,394567,555010,1018893,321398,361038,442176,384427,117398,312700,65142,389224,115414,885155,577806,431787,544695,350000,742249,978584,794728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000842s ]