SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311294 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311294 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569525,874618,437560,254759,1043200,965186,761866,1017607,598213,299094,680818,482741,667717,800033,462648,880337,805820,231896,167086,936466,849775,938320,351484,277561,486057,449468,729735,177796,709019,63195,613026,644949,780297,102692,1007810,548812,877526,288132,191316,830120,102992,681751,207805,1013355,583225,242524,755625,923398,971762,875651,471956,275069,168658,867221,481323,782648,395623,346315,597702,269459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]