SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502542 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502542 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427355,679566,206806,122856,764126,615499,509894,1046262,99366,265003,438891,2208,251637,916082,780281,103595,141496,721821,23353,459392,367965,321315,1019679,483907,811024,529482,691520,696797,745378,113440,502787,757227,430206,901967,812116,812238,821706,446045,950308,689162,65334,710616,869079,904098,833350,500224,255271,427705,335417,792754,988219,491944,311928,698185,838149,334826,349965,750225,457176,294022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]