SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001731s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038186 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038186 [ RunTime:0.002193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474704,707770,804129,757463,297441,706627,1006965,281711,216009,540432,10736,780652,963412,219791,910720,537456,937457,953773,67606,155469,896006,802513,559188,283706,434448,550663,306447,940632,37823,242759,202090,729778,486484,106917,293208,1032706,143095,538722,296217,805079,486173,644964,854625,420527,291699,10163,791594,85800,387742,609111,157595,127201,132294,851424,814084,183771,986740,779215,601019,917219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]