SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104470 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104470 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391698,617656,646146,396802,624565,613659,798118,527786,81158,763826,651076,210195,229491,838099,506640,363815,833227,838180,457912,1041942,51010,914099,529618,261926,148834,235024,318119,477637,1046390,778552,801464,219262,386393,459781,236475,95013,935463,244434,523331,101964,858763,23142,985139,676680,325287,605477,687455,190089,687412,388443,266118,1035168,703305,162401,562859,990910,585250,1030982,566742,552917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002136s ]