SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409813 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409813 [ RunTime:0.002569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399346,88686,794582,622565,931592,291937,372295,931997,193716,830791,205615,747418,399291,698154,422866,436380,621650,597222,229381,108214,275819,788439,279253,538577,643925,579663,159452,626903,447945,346749,448999,124726,51729,58424,532392,233214,190007,1032346,638983,243138,356357,609879,262551,917249,510025,474073,363669,668033,487235,952957,904216,936999,722648,867653,948643,273192,387799,363559,242748,278026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]