SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 121413 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121413 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863797,826480,268574,635296,1007035,463052,480983,1004921,1021021,71736,537348,303812,826840,706045,589338,254111,523954,805960,640967,931347,19548,734865,192403,833648,28133,884519,629096,1024578,506865,923832,89724,210800,103858,917479,757788,245533,138937,93795,980717,715028,239105,259080,275066,239235,889845,345018,333254,943431,592265,922613,310735,934263,546366,1046327,582818,528918,410550,787193,304856,703213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]