SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510631 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510631 [ RunTime:0.003838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874542,865972,1043669,756374,191922,26606,773067,101677,877903,749772,698401,888878,554084,806413,939313,440626,956631,1030433,32234,575533,4540,835527,155542,211859,262995,788858,238229,369075,456514,937054,417245,664804,803504,314707,129644,770353,439948,468675,376948,377369,943314,146392,636063,292371,602112,534648,891030,980991,547196,1001863,742387,45302,667570,83945,451789,777982,541682,164781,452413,879848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000756s ]