SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005095 LIMIT 1 [ RunTime:0.001336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005095 [ RunTime:0.003141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540775,1004602,534712,771411,779049,367775,465157,133999,460774,156260,1039163,102235,923198,640216,343295,436262,614203,515787,118711,215848,148519,1028541,402272,260928,67786,478887,1048307,424749,1000986,334188,916309,89771,870374,771244,722916,34408,401686,518965,542046,111753,762645,843723,732024,767419,491986,952547,65557,269437,542670,1009709,64157,121920,389700,799349,408252,741165,325697,825995,465677,666597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002796s ]