SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114818 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114818 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174889,1035796,161237,363968,720951,383110,304416,551332,807936,91864,721027,471220,568962,852162,890083,981821,195027,487729,809995,817163,976219,172823,907135,126666,397226,292913,202812,538297,194940,327074,166872,720471,314006,135368,721772,904262,1024933,65368,560371,808236,366083,491177,265022,277307,872020,446137,993175,826571,455356,997458,1011102,382087,86205,323962,225820,575000,375443,868949,185594,884953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]