SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 119718 LIMIT 1 [ RunTime:0.001340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 119718 [ RunTime:0.003189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808745,948527,872812,988776,481247,780294,73149,848343,502395,609268,1041793,1022722,355039,960288,451993,380432,498355,655585,945074,707947,871276,252759,983792,905995,601010,781060,263575,644732,194728,857013,595359,556413,16743,285644,527474,1038666,496724,559621,655774,659532,155445,868859,493804,64294,798849,466947,859291,381535,313815,400647,438258,300663,521155,329140,587694,657191,442792,680984,684512,464315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 119718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 119718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]