SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012073 LIMIT 1 [ RunTime:0.000759s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012073 [ RunTime:0.002408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202514,805301,811775,674783,439646,811917,615475,757076,611446,87610,139418,669335,563549,244256,933822,856043,352324,1004132,1046137,25627,507017,942192,55180,401044,305048,835518,615838,794758,252324,160015,788546,271256,975038,1007938,39369,924871,244200,295416,383791,824205,47474,823241,98477,737712,1019302,442496,31349,1032138,359112,325816,721996,1012292,325251,1007776,870363,966863,998302,485980,719504,119133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]