SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423301 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423301 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768621,202467,896612,359677,523970,206312,243391,365700,910828,568770,9522,521883,445995,269011,832495,173863,639396,650424,966677,14109,109609,728828,994407,670814,736122,504896,565692,923487,933780,348732,398327,443806,844693,801874,787583,930440,819998,733359,410774,153117,610906,618787,383538,714711,158149,925599,376817,165399,85486,275141,262268,1044119,1004732,857668,79924,894584,630596,96653,1040487,193628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]