SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524326 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524326 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988597,622280,83031,918321,109511,608853,454712,684277,418459,820803,826642,960590,769370,157583,425574,604314,491224,75961,863287,329167,646737,1047133,649121,557896,794375,746007,976428,367173,553190,389168,901778,284698,1034380,135677,1013814,635754,261116,810720,462664,796897,174962,251291,399912,182092,220600,238490,659360,853131,419587,856907,209507,357879,366671,452433,446801,407676,214820,539529,216894,1010974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]