SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47542 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47542 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492575,141519,429158,235342,980686,809627,371750,990857,70286,169729,982004,345454,137131,409511,490314,823990,88433,147612,74027,428913,100714,947275,1026469,324248,1000662,867400,263284,672945,916664,105344,810070,835366,638818,180017,835157,134321,1020774,109694,959674,708368,895213,365312,800722,616208,894274,378743,210721,804080,1047038,869555,929109,212779,110728,547973,848985,1021609,704929,726345,738109,888557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]