SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017042 LIMIT 1 [ RunTime:0.003033s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017042 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379803,345561,641881,701374,26715,414966,90573,570126,1042902,390052,1007672,1005514,267761,596533,654024,575312,891783,3627,663781,219061,769654,546117,205192,748713,334080,248615,319077,25192,1045552,562862,749941,121515,868338,131353,580141,696276,645652,744486,138909,474408,490721,667349,760405,1046797,768930,545228,556839,713117,633929,977116,658320,255270,1031593,750875,370033,602318,366630,927617,848537,145545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]