SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41896 LIMIT 1 [ RunTime:0.001395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41896 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434,1039887,996488,146488,646468,459861,358357,890755,276980,33549,408272,874876,178775,837257,643810,428950,719299,538473,775533,464235,806651,692156,931378,595160,577527,1047,502940,23070,51864,1031853,703858,520470,1034465,269273,426405,753158,900269,964228,250156,726902,253123,326212,686839,787255,927599,778337,317301,684741,565579,717530,525194,305702,826918,10732,408810,398009,913442,220517,1028051,774484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]