SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286909 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286909 [ RunTime:0.004365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764818,606931,252493,570777,503381,912245,149283,220203,622222,378318,455935,384102,490718,571334,233066,945589,361818,254315,211664,298122,572734,689842,701403,820250,306627,1017541,517627,409171,679957,142189,891382,753879,845739,231689,636838,862896,702874,159553,41350,564147,403180,920388,357737,817553,411373,738255,932218,745631,8330,609579,777778,295019,22422,1043806,416161,676162,52424,1030924,209102,919157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002574s ]